Nathan Bush
Advanced Data Analytics
Do state politics interfere with decision making?
Are states acting in their own best interest?
Understand these dynamics to best inform policy
Energy usage statistics by state - US Energy Information Administration
2000-2020 presidential election data -MIT Election and Data Science Lab & the Harvard Dataverse
2022 State Governors -Webscraped from Wikipedia —
Energy Use Data - This dataset needed the most work - Removed rows containing non-data entries - Removed variables unnecessary to my analysis - Applied transformations to key variables - (* = 0 | –, NM = N/A)
Election Data - Clean Dataset…tricky variable creation - Summed votes for candidates within states to determine victor - Dummy variable = 1 if a state voted for Trump
Governor Data - Webscraped Wikipedia Table - Easy to clean and process - Dummy variable = 1 if a state has a republican governor
Question 1
Are there discernible differences between renewable energy use based on political affiliation between states?
Three Categories - Red - Blue - Purple
## $tm_shape
## $tm_shape$shp_name
## [1] "final_map"
##
## $tm_shape$shp
## state labor_force GDP Vehicle Miles Traveled (million miles)
## 1 AL 2.3 247.1 67921
## 3 AZ 3.6 411.2 65758
## 4 AR 1.4 144.5 33919
## 5 CA 19.2 3356.6 299812
## 6 CO 3.2 421.9 48642
## 7 CT 1.9 296.5 29845
## 8 DE 0.5 80.7 8345
## 9 FL 10.7 1226.3 208076
## 10 GA 5.3 683.3 115967
## 12 ID 1.0 94.3 17406
## 13 IL 6.5 938.3 94121
## 14 IN 3.4 420.3 76608
## 15 IA 1.7 219.8 29751
## 16 KS 1.5 192.3 27854
## 17 KY 2.1 234.5 46536
## 18 LA 2.1 255.3 48374
## 19 ME 0.7 76.1 13086
## 20 MD 3.2 438.2 50885
## 21 MA 3.8 636.5 54127
## 22 MI 4.9 568.4 86547
## 23 MN 3.1 412.0 51619
## 24 MS 1.3 125.1 39665
## 25 MO 3.1 360.0 72797
## 26 MT 0.6 59.3 12104
## 27 NE 1.1 150.4 19432
## 28 NV 1.5 193.0 25231
## 29 NH 0.8 98.2 11956
## 30 NJ 4.7 672.1 66341
## 31 NM 0.9 108.9 23756
## 32 NY 9.6 1853.9 102477
## 33 NC 5.2 655.0 106342
## 34 ND 0.4 63.4 8768
## 35 OH 5.8 736.4 103115
## 36 OK 1.9 206.8 42000
## 37 OR 2.2 266.9 32298
## 38 PA 6.5 839.4 87982
## 39 RI 0.6 65.9 6864
## 40 SC 2.4 270.1 53972
## 41 SD 0.5 61.2 9743
## 42 TN 3.4 418.3 76392
## 43 TX 14.6 1985.3 260582
## 44 UT 1.7 220.3 30251
## 45 VT 0.3 36.2 6007
## 46 VA 4.4 591.9 76110
## 47 WA 4.0 667.6 53658
## 48 WV 0.8 87.4 16054
## 49 WI 3.1 365.9 57600
## 50 WY 0.3 41.6 9800
## Land in Farms (million acres) avg_temp precip Petroleum-Fired (%)
## 1 8.6 64.3 64.9 0
## 3 25.1 62.1 12.7 0
## 4 13.9 61.2 50.9 0.1
## 5 24.5 60.4 18.8 0
## 6 31.8 47.5 17.0 <NA>
## 7 0.4 51.4 51.1 0.5
## 8 0.5 57.6 40.6 <NA>
## 9 9.7 72.3 56.1 0.1
## 10 10 64.5 57.1 0.2
## 12 11.7 45.4 21.0 0
## 13 27 53.7 41.1 0
## 14 15 53.5 45.3 0.1
## 15 30.6 50 31.1 0.2
## 16 45.8 56.1 27.2 <NA>
## 17 13 56.9 53.3 0.1
## 18 8 67.5 66.3 <NA>
## 19 1.3 44.2 39.4 0.2
## 20 2 56.9 41.5 0.5
## 21 0.5 50.8 54.8 <NA>
## 22 9.8 47.4 32.9 0.1
## 23 25.5 44.3 23.7 0.1
## 24 10.4 64.9 66.8 <NA>
## 25 27.8 56.3 44.0 0.1
## 26 59.8 44 14.4 <NA>
## 27 45 51 22.6 <NA>
## 28 6.1 52.5 9.5 0
## 29 0.4 46.1 46.0 <NA>
## 30 0.7 55.2 48.0 0.1
## 31 40.7 55.4 12.4 0
## 32 6.9 47.8 46.3 0.3
## 33 8.4 60.1 47.3 0.1
## 34 39.3 43.8 15.6 0.1
## 35 14 53.2 41.5 0.1
## 36 34.2 60.8 33.6 0
## 37 16 49.2 28.5 <NA>
## 38 7.3 51.1 46.1 0
## 39 0.1 52.6 49.9 <NA>
## 40 4.7 63.7 47.3 0.1
## 41 43.2 48 18.2 <NA>
## 42 10.9 59 58.8 0.2
## 43 127 66.1 28.9 0
## 44 10.8 50.7 13.6 0.1
## 45 1.2 45 41.8 <NA>
## 46 7.8 57 40.8 0.3
## 47 14.7 48.3 43.9 <NA>
## 48 3.7 53.7 42.4 0.4
## 49 14.3 45.7 30.0 0
## 50 29 43.6 14.4 0.2
## Coal-Fired (%) Nuclear (%) Renewables Motor Gas
## 1 15.5 28.5 8.4 61
## 3 14.8 29.3 14.7 63
## 4 26.5 22.8 7.8 121
## 5 0.1 8.8 50.9 404
## 6 36.4 <NA> 37.5 173
## 7 0 36.5 3.3 <NA>
## 8 4.4 <NA> 3.0 <NA>
## 9 5.6 11 6.0 379
## 10 16 23.1 11.8 73
## 12 <NA> <NA> 86.7 51
## 13 22 51.8 9.8 33
## 14 55.6 <NA> 9.1 84
## 15 30.8 <NA> 57.5 44
## 16 37.2 14.9 40.6 265
## 17 66 <NA> 6.5 40
## 18 9.1 8.7 3.1 975
## 19 0.2 <NA> 64.5 <NA>
## 20 11.1 37.3 6.5 <NA>
## 21 0 <NA> 23.4 4
## 22 29.5 22.7 10.9 13
## 23 28.8 25.4 30.1 256
## 24 10.3 14.5 2.4 1231
## 25 64 12.5 9.4 146
## 26 33.1 <NA> 63.6 302
## 27 55.6 14.6 27.2 46
## 28 6.7 <NA> 39.6 171
## 29 0 55.3 11.3 <NA>
## 30 0.1 39.6 4.0 <NA>
## 31 38.7 <NA> 38.2 22
## 32 0 21.8 27.2 1
## 33 10.9 30.4 15.9 68
## 34 59.3 <NA> 38.1 54
## 35 32.3 12.9 3.2 540
## 36 14.5 <NA> 41.4 204
## 37 <NA> <NA> 90.3 67
## 38 5.8 32.9 3.0 <NA>
## 39 0 <NA> 12.0 <NA>
## 40 14.4 51.4 7.3 95
## 41 13.3 <NA> 81.4 15
## 42 26.8 31.7 15.6 29
## 43 16.2 7.1 25.4 3962
## 44 53.7 <NA> 20.4 99
## 45 <NA> <NA> 99.8 <NA>
## 46 4.4 29.5 11.5 8
## 47 0 5.8 90.1 539
## 48 89.7 <NA> 4.9 41
## 49 30.6 16.3 11.6 54
## 50 69.7 <NA> 24.6 360
## Total Expenditures ($ million)
## 1 18570
## 3 20340
## 4 10368
## 5 114485
## 6 15449
## 7 11540
## 8 3153
## 9 51441
## 10 31018
## 12 5949
## 13 34115
## 14 24287
## 15 12694
## 16 10263
## 17 15508
## 18 24234
## 19 4885
## 20 15952
## 21 20902
## 22 29070
## 23 17647
## 24 10581
## 25 18888
## 26 4402
## 27 7637
## 28 8778
## 29 4621
## 30 24827
## 31 6791
## 32 47968
## 33 28737
## 34 4848
## 35 34994
## 36 13106
## 37 12066
## 38 37545
## 39 3140
## 40 16657
## 41 3714
## 42 21401
## 43 108196
## 44 8709
## 45 2325
## 46 25577
## 47 19932
## 48 6729
## 49 18496
## 50 3869
## Utility-Scale Biomass Net Electricity Generation (thousand MWh) Solar
## 1 275 NA
## 3 18 360
## 4 77 23
## 5 476 2385
## 6 15 136
## 7 59 110
## 8 6 17
## 9 343 230
## 10 489 NA
## 12 39 19
## 13 33 136
## 14 36 30
## 15 17 33
## 16 5 8
## 17 32 10
## 18 186 27
## 19 161 34
## 20 24 133
## 21 93 287
## 22 210 28
## 23 122 27
## 24 117 2
## 25 13 60
## 26 3 6
## 27 7 4
## 28 5 131
## 29 92 25
## 30 58 326
## 31 <NA> 54
## 32 165 370
## 33 180 58
## 34 <NA> 0
## 35 44 36
## 36 27 8
## 37 84 48
## 38 139 86
## 39 20 54
## 40 199 49
## 41 <NA> 0
## 42 57 9
## 43 153 314
## 44 6 78
## 45 31 23
## 46 331 38
## 47 120 45
## 48 <NA> 3
## 49 111 24
## 50 <NA>